AROS
The Amiga Replacement OS
(C) 1996 AROS - The Amiga Replacement OS
Enter the mSQL command below:
The jobserver consists of the following tables:
- jobs
Fields:
- jobid (eg. intuition00105)
- status (0 = free, 1 = in work, 2 = done)
- email (login of the user. The name should really
be login instead of email.)
- comment (eg. Write xyz)
Here is a list of the most useful queries. You don't need to copy
case when entering them (ie. SELECT is the same as select).
-
SELECT * FROM jobs WHERE email='digulla'
would show all infos about all jobs which were added, allocated and
finished by me.
-
SELECT status,comment FROM jobs WHERE email='digulla'
would do the same but only the status and the comment of the jobs
would be listed.
-
SELECT * FROM jobs WHERE email='digulla' ORDER BY status,comment
would return an ordered list.
-
INSERT INTO jobs(jobid,email,comment)
VALUES('new00001','digulla','Demo job')
would add a new entry to the table. The jobid would be new00001, the email
(login) digulla and the comment "Demo job".
-
DELETE FROM jobs WHERE jobid='new00001'
would delete the job added with the rule right before.
-
UPDATE jobs SET email='digulla',status=2 WHERE email<>'digulla'
would mark all jobs as completed by me (except those which are added or
allocated by me) ;-)
For a complete descriptions of mSQL commands and options, have a look
at the mSQL 2.0
Manual at Hughes Technologies.
If you have comments or suggestions, email me at
digulla@aros.fh-konstanz.de
. 22 Jul 1997